package xiangmu.schoolpaper.mapper.system;

import org.apache.ibatis.annotations.Mapper;
import xiangmu.schoolpaper.pojo.VO.SystemTeacherInfoVO;

import java.util.List;

@Mapper
public interface SystemStatisticAnalysisMapper {
//    3获取所有老师工号和姓名
    List<SystemTeacherInfoVO> getAllTeachers();
//    4某年份下所有专业
    List<String> getAllMajorsByYear(Integer year);
//    5某年份下所有老师
    List<SystemTeacherInfoVO> getAllTeachersByYear(Integer year);
//    6某专业下所有年份
    List<String> getAllYearsByMajor(String major);
//    7某老师下所有年份
    List<String> getAllYearsByTeacherAccount(String teacherAccount);
}
